package com.example.zuoye4.mapper;

import com.example.zuoye4.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper

public interface UserMapper {
    @Select("select * from user where id = #{id}")
    User getUserById(Integer id);
    @Select("select * from user")
    List<User> getAllUser();
    @Select("select * from user limit #{limit} offset #{offset}")
    List<User> getUserByPage(Integer limit, Integer offset);
}
